Salesforce Connector Predicate Functions

CONVERTCURRENCY(column)

Returns the currency field converted to the user's currency

CALENDAR_MONTH(column)

Returns a number representing the calendar month of a date field (1 for January, 12 for December).

CALENDAR_QUARTER(column)

Returns a number representing the calendar quarter of a date field (1 for January 1 through March 31, 2 for April 1 through June 30, 3 for July 1 through September 30, 4 for October 1 through December 31).

CALENDAR_YEAR(column)

Returns a number representing the calendar year of a date field (2009).

DAY_IN_MONTH(column)

Returns a number representing the day in the month of a date field (20 for February 20).

DAY_IN_WEEK(column)

Returns a number representing the day of the week for a date field (1 for Sunday, 7 for Saturday).

DAY_IN_YEAR(column)

Returns a date representing the day portion of a dateTime field (32 for February 1).

DAY_ONLY(column)

Returns a date representing the day portion of a dateTime field (2009-09-22 for September 22, 2009).

FISCAL_MONTH(column)

Returns a number representing the fiscal month of a date field. This differs from CALENDAR_MONTH() if your organization uses a fiscal year that does not match the Gregorian calendar. If your fiscal year starts in March: 1 for March, 12 for February.

FISCAL_QUARTER(column)

Returns a number representing the fiscal quarter of a date field. This differs from CALENDAR_QUARTER() if your organization uses a fiscal year that does not match the Gregorian calendar. If your fiscal year starts in July: 1 for July 15, 4 for June 6.

FISCAL_YEAR(column)

Returns a number representing the fiscal year of a date field. This differs from CALENDAR_YEAR() if your organization uses a fiscal year that does not match the Gregorian calendar (2009).

HOUR_IN_DAY(column)

Returns a number representing the hour in the day for a dateTime field (18 for a time of 18:23:10).

WEEK_IN_MONTH(column)

Returns a number representing the week in the month for a date field (2 for April 10). The first week is from the first through the seventh day of the month.

WEEK_IN_YEAR(column)

Returns a number representing the week in the year for a date field (1 for January 3). The first week is from January 1 through January 7.